﻿using System;
namespace IService.DataDLL
{
    interface IDBHelper
    {
        void Close();
        string ConnectionKey { get; set; }
        string ConnectionString { get; set; }
        System.Data.OleDb.OleDbConnection DbConn();
        bool ExecuteBoolWithCommand(string CommandText, params System.Data.IDataParameter[] Parameters);
        System.Data.DataSet ExecuteDataSetWithCommand(string CommandText, params System.Data.IDataParameter[] Parameters);
        System.Data.DataTable ExecuteDataTableWithCommand(string CommandText, params System.Data.IDataParameter[] Parameters);
        int ExecuteNonQueryWithCommand(string CommandText, params System.Data.IDataParameter[] Parameters);
        object ExecuteScalar(string SQL);
        object ExecuteScalarWithCommand(string CommandText, params System.Data.IDataParameter[] Parameters);
        bool ExecuteSqlCommand(System.Data.IDbCommand cmd);
        bool ExecuteSQLNonquery(string SQL);
        int GetRecordCount(string TableName, string WhereClause);
        System.Data.DataSet SelectToDataSet(string SQL);
        System.Data.DataSet SelectToDataSet(string SQL, string subtableName, System.Data.DataSet DataSetName);
        System.Data.DataTable SelectToDataTable(string SQL);
        System.Data.OleDb.OleDbDataAdapter SelectToOleDbDataAdapter(string SQL);
    }
}
